//
//  DataBase.h
//  Lesson_SQL
//
//  Created by dlios on 15-8-25.
//  Copyright (c) 2015年 lanou3g.com 蓝鸥科技. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "BaseHeader.h"
#import "PlayModel.h"

//使用数据库之前  先导入库文件libsqlite3.0dylib文件  然后引入sqlite3.h文件
@interface DataBase : NSObject
+(DataBase *)shareDataBase;
-(void)openDB;//打开数据库
-(void)createTable;//创建数据库表
-(void)insertStudent:(PlayModel *)model;
-(void)updateStudent:(PlayModel *)model number:(NSInteger)number;//根据number更新学生信息
-(void)deleteStudent:(NSString *)title;

-(NSMutableArray *)selectAll;
-(void)closeDB;
-(void)dropTable;
@end
